﻿


  
using System;
using SubSonic;
using SubSonic.Schema;
using SubSonic.DataProviders;
using System.Data;
namespace MvcForum.Net.Business{
public partial class MainDB{

	public StoredProcedure AdvancedSearch(string Sql){
							var sp=new StoredProcedure("MF_AdvancedSearch",this.Provider);
									sp.Command.AddParameter("Sql", Sql,DbType.String,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ChangePassword(int UserId, string OldPwd, string NewPwd){
							var sp=new StoredProcedure("MF_ChangePassword",this.Provider);
									sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("OldPwd", OldPwd,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("NewPwd", NewPwd,DbType.AnsiString,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("RETURN_VALUE",DbType.Boolean);
									return sp;
				}
				
				
	public StoredProcedure EmailExists(string Email){
							var sp=new StoredProcedure("MF_EmailExists",this.Provider);
									sp.Command.AddParameter("Email", Email,DbType.AnsiString,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("RETURN_VALUE",DbType.Boolean);
									return sp;
				}
				
				
	public StoredProcedure FindPost(int TopicId){
							var sp=new StoredProcedure("MF_FindPost",this.Provider);
									sp.Command.AddParameter("TopicId", TopicId,DbType.Int32,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("TotalRows",DbType.Int32);
									return sp;
				}
				
				
	public StoredProcedure ForumDetail(int ForumId){
							var sp=new StoredProcedure("MF_ForumDetail",this.Provider);
									sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ForumList(int ParentId, int MaxRecursion, bool VisibleAtHomePage){
							var sp=new StoredProcedure("MF_ForumList",this.Provider);
									sp.Command.AddParameter("ParentId", ParentId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("MaxRecursion", MaxRecursion,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("VisibleAtHomePage", VisibleAtHomePage,DbType.Boolean,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ForumList2(int ParentId, int MaxRecursion, bool VisibleAtHomePage){
							var sp=new StoredProcedure("MF_ForumList2",this.Provider);
									sp.Command.AddParameter("ParentId", ParentId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("MaxRecursion", MaxRecursion,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("VisibleAtHomePage", VisibleAtHomePage,DbType.Boolean,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ForumSave(int ForumId, string ForumName, int ParentId, string Keywords, string Description, short SortOrder, string RemoteUrl, bool IsLocked, bool AllowPostWithIn, short ModerateType, string AllowRoles, bool VisibleAtHomePage){
							var sp=new StoredProcedure("MF_ForumSave",this.Provider);
									sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("ForumName", ForumName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("ParentId", ParentId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("Keywords", Keywords,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Description", Description,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("SortOrder", SortOrder,DbType.Int16,ParameterDirection.Input);
													sp.Command.AddParameter("RemoteUrl", RemoteUrl,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("IsLocked", IsLocked,DbType.Boolean,ParameterDirection.Input);
													sp.Command.AddParameter("AllowPostWithIn", AllowPostWithIn,DbType.Boolean,ParameterDirection.Input);
													sp.Command.AddParameter("ModerateType", ModerateType,DbType.Int16,ParameterDirection.Input);
													sp.Command.AddParameter("AllowRoles", AllowRoles,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("VisibleAtHomePage", VisibleAtHomePage,DbType.Boolean,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ForumStatistics(int PastMinutes){
							var sp=new StoredProcedure("MF_ForumStatistics",this.Provider);
									sp.Command.AddParameter("PastMinutes", PastMinutes,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ForumStatisUpdateMaxOnline(int PastMinutes){
							var sp=new StoredProcedure("MF_ForumStatisUpdateMaxOnline",this.Provider);
									sp.Command.AddParameter("PastMinutes", PastMinutes,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ForumsTotalTopicsOrPosts(int ForumId){
							var sp=new StoredProcedure("MF_ForumsTotalTopicsOrPosts",this.Provider);
									sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("TopicCount",DbType.Int32);
						
							sp.Command.AddOutputParameter("PostCount",DbType.Int32);
									return sp;
				}
				
				
	public StoredProcedure ForumSubToParent(int ForumId){
							var sp=new StoredProcedure("MF_ForumSubToParent",this.Provider);
									sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ForumUpdateLastPost(int ForumId, int TopicsNumber, int RepliesNumber, string UserName, int LastPostId, string LastPostTitle){
							var sp=new StoredProcedure("MF_ForumUpdateLastPost",this.Provider);
									sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("TopicsNumber", TopicsNumber,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("RepliesNumber", RepliesNumber,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("UserName", UserName,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("LastPostId", LastPostId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("LastPostTitle", LastPostTitle,DbType.String,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure LogIn(string UserName, string Pwd, bool IsUpdateLogin){
							var sp=new StoredProcedure("MF_LogIn",this.Provider);
									sp.Command.AddParameter("UserName", UserName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Pwd", Pwd,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("IsUpdateLogin", IsUpdateLogin,DbType.Boolean,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure ModeratorList(int UserId){
							var sp=new StoredProcedure("MF_ModeratorList",this.Provider);
									sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure QuickSearch(int ForumId, string Keyword, short ResultType, int MaxResults){
							var sp=new StoredProcedure("MF_QuickSearch",this.Provider);
									sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("Keyword", Keyword,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("ResultType", ResultType,DbType.Int16,ParameterDirection.Input);
													sp.Command.AddParameter("MaxResults", MaxResults,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure Register(string UserName, string Pwd, string Email, double TimeZone, string ActiveCode){
							var sp=new StoredProcedure("MF_Register",this.Provider);
									sp.Command.AddParameter("UserName", UserName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Pwd", Pwd,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("Email", Email,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("TimeZone", TimeZone,DbType.Double,ParameterDirection.Input);
													sp.Command.AddParameter("ActiveCode", ActiveCode,DbType.AnsiString,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure RoleList(){
							var sp=new StoredProcedure("MF_RoleList",this.Provider);
						return sp;
				}
				
				
	public StoredProcedure RoleSave(int RoleId, string RoleName, bool IsAutoStart, bool IsAdmin, string CssClass, string AccessMask){
							var sp=new StoredProcedure("MF_RoleSave",this.Provider);
									sp.Command.AddParameter("RoleId", RoleId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("RoleName", RoleName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("IsAutoStart", IsAutoStart,DbType.Boolean,ParameterDirection.Input);
													sp.Command.AddParameter("IsAdmin", IsAdmin,DbType.Boolean,ParameterDirection.Input);
													sp.Command.AddParameter("CssClass", CssClass,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("AccessMask", AccessMask,DbType.AnsiString,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure SmilesList(){
							var sp=new StoredProcedure("MF_SmilesList",this.Provider);
						return sp;
				}
				
				
	public StoredProcedure StatisticMaxOnline(){
							var sp=new StoredProcedure("MF_StatisticMaxOnline",this.Provider);
						return sp;
				}
				
				
	public StoredProcedure ThanksSave(int TopicId, int UserId, string UserName, int Action){
							var sp=new StoredProcedure("MF_ThanksSave",this.Provider);
									sp.Command.AddParameter("TopicId", TopicId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("UserName", UserName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Action", Action,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure TimeZoneList(){
							var sp=new StoredProcedure("MF_TimeZoneList",this.Provider);
						return sp;
				}
				
				
	public StoredProcedure TopicDetail(int TopicId){
							var sp=new StoredProcedure("MF_TopicDetail",this.Provider);
									sp.Command.AddParameter("TopicId", TopicId,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure TopicsDelete(string Ids, bool Del){
							var sp=new StoredProcedure("MF_TopicsDelete",this.Provider);
									sp.Command.AddParameter("Ids", Ids,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("Del", Del,DbType.Boolean,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure TopicsList(int ForumId, bool IsModerator, int PageIndex, int PageSize){
							var sp=new StoredProcedure("MF_TopicsList",this.Provider);
									sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("IsModerator", IsModerator,DbType.Boolean,ParameterDirection.Input);
													sp.Command.AddParameter("PageIndex", PageIndex,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PageSize", PageSize,DbType.Int32,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("TotalRows",DbType.Int32);
									return sp;
				}
				
				
	public StoredProcedure TopicsLockUpdate(string Ids, bool Val){
							var sp=new StoredProcedure("MF_TopicsLockUpdate",this.Provider);
									sp.Command.AddParameter("Ids", Ids,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("Val", Val,DbType.Boolean,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure TopicsMoveToForum(string Ids, int ForumId){
							var sp=new StoredProcedure("MF_TopicsMoveToForum",this.Provider);
									sp.Command.AddParameter("Ids", Ids,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure TopicsPostsList(int TopicId, int PageIndex, int PageSize, bool IsModerator){
							var sp=new StoredProcedure("MF_TopicsPostsList",this.Provider);
									sp.Command.AddParameter("TopicId", TopicId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PageIndex", PageIndex,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PageSize", PageSize,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("IsModerator", IsModerator,DbType.Boolean,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("TotalRows",DbType.Int32);
									return sp;
				}
				
				
	public StoredProcedure TopicsPriorityUpdate(string Ids, short Priority, DateTime PriorityDate){
							var sp=new StoredProcedure("MF_TopicsPriorityUpdate",this.Provider);
									sp.Command.AddParameter("Ids", Ids,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("Priority", Priority,DbType.Int16,ParameterDirection.Input);
													sp.Command.AddParameter("PriorityDate", PriorityDate,DbType.DateTime,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure TopicsQueueUpdate(string Ids, bool Val){
							var sp=new StoredProcedure("MF_TopicsQueueUpdate",this.Provider);
									sp.Command.AddParameter("Ids", Ids,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("Val", Val,DbType.Boolean,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure TopicsRssFetch(int ForumId, int Top){
							var sp=new StoredProcedure("MF_TopicsRssFetch",this.Provider);
									sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("Top", Top,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure TopicsSave(int TopicId, string TopicName, int ForumId, int PollId, string Icon, string Message, int ReplyTo, int Priority, DateTime PriorityDate, bool IsApproved, string EditedBy, string RemoteUrl, string UserName, int UserId, string IP){
							var sp=new StoredProcedure("MF_TopicsSave",this.Provider);
									sp.Command.AddParameter("TopicId", TopicId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("TopicName", TopicName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PollId", PollId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("Icon", Icon,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("Message", Message,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("ReplyTo", ReplyTo,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("Priority", Priority,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PriorityDate", PriorityDate,DbType.DateTime,ParameterDirection.Input);
													sp.Command.AddParameter("IsApproved", IsApproved,DbType.Boolean,ParameterDirection.Input);
													sp.Command.AddParameter("EditedBy", EditedBy,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("RemoteUrl", RemoteUrl,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("UserName", UserName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("IP", IP,DbType.AnsiString,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("RETURN_VALUE",DbType.Int32);
									return sp;
				}
				
				
	public StoredProcedure TopicThankList(int TopicId, int PageIndex, int PageSize){
							var sp=new StoredProcedure("MF_TopicThankList",this.Provider);
									sp.Command.AddParameter("TopicId", TopicId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PageIndex", PageIndex,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PageSize", PageSize,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure UserInfo(int UserId, string UserNameOrEmail){
							var sp=new StoredProcedure("MF_UserInfo",this.Provider);
									sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("UserNameOrEmail", UserNameOrEmail,DbType.AnsiString,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure UserNameExists(string UserName){
							var sp=new StoredProcedure("MF_UserNameExists",this.Provider);
									sp.Command.AddParameter("UserName", UserName,DbType.String,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("RETURN_VALUE",DbType.Boolean);
									return sp;
				}
				
				
	public StoredProcedure UserPasswordExists(string UserName, string Pwd){
							var sp=new StoredProcedure("MF_UserPasswordExists",this.Provider);
									sp.Command.AddParameter("UserName", UserName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Pwd", Pwd,DbType.AnsiString,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("RETURN_VALUE",DbType.Boolean);
									return sp;
				}
				
				
	public StoredProcedure UsersActionsList(int PageIndex, int PageSize){
							var sp=new StoredProcedure("MF_UsersActionsList",this.Provider);
									sp.Command.AddParameter("PageIndex", PageIndex,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PageSize", PageSize,DbType.Int32,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("TotalRows",DbType.Int32);
									return sp;
				}
				
				
	public StoredProcedure UsersActionsSave(string SessionId, int UserId, string UserName, string IP, DateTime LastAction, string PageTitle, string Location, int ForumId, int TopicId, string Browser, string Platform, int PastMinutes){
							var sp=new StoredProcedure("MF_UsersActionsSave",this.Provider);
									sp.Command.AddParameter("SessionId", SessionId,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("UserName", UserName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("IP", IP,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("LastAction", LastAction,DbType.DateTime,ParameterDirection.Input);
													sp.Command.AddParameter("PageTitle", PageTitle,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Location", Location,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("ForumId", ForumId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("TopicId", TopicId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("Browser", Browser,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Platform", Platform,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("PastMinutes", PastMinutes,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure UsersActive(string ActiveCode, string Email){
							var sp=new StoredProcedure("MF_UsersActive",this.Provider);
									sp.Command.AddParameter("ActiveCode", ActiveCode,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("Email", Email,DbType.AnsiString,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure UsersInBirthday(){
							var sp=new StoredProcedure("MF_UsersInBirthday",this.Provider);
						return sp;
				}
				
				
	public StoredProcedure UsersList(int PageIndex, int PageSize){
							var sp=new StoredProcedure("MF_UsersList",this.Provider);
									sp.Command.AddParameter("PageIndex", PageIndex,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("PageSize", PageSize,DbType.Int32,ParameterDirection.Input);
							
							sp.Command.AddOutputParameter("TotalRows",DbType.Int32);
									return sp;
				}
				
				
	public StoredProcedure UsersOnline(int PastMinutes){
							var sp=new StoredProcedure("MF_UsersOnline",this.Provider);
									sp.Command.AddParameter("PastMinutes", PastMinutes,DbType.Int32,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure UsersResetPwd(int UserId, string Pwd){
							var sp=new StoredProcedure("MF_UsersResetPwd",this.Provider);
									sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("Pwd", Pwd,DbType.AnsiString,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure UsersSaveContactDetails(int UserId, string FullName, string Address, byte Sex, DateTime BirthDay, string Website, string Blog, string YahooId, string SkypeId, string MSN, string AOL){
							var sp=new StoredProcedure("MF_UsersSaveContactDetails",this.Provider);
									sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("FullName", FullName,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Address", Address,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Sex", Sex,DbType.Byte,ParameterDirection.Input);
													sp.Command.AddParameter("BirthDay", BirthDay,DbType.DateTime,ParameterDirection.Input);
													sp.Command.AddParameter("Website", Website,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("Blog", Blog,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("YahooId", YahooId,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("SkypeId", SkypeId,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("MSN", MSN,DbType.String,ParameterDirection.Input);
													sp.Command.AddParameter("AOL", AOL,DbType.String,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure UsersSaveEmailSignature(int UserId, string Email, string Signature){
							var sp=new StoredProcedure("MF_UsersSaveEmailSignature",this.Provider);
									sp.Command.AddParameter("UserId", UserId,DbType.Int32,ParameterDirection.Input);
													sp.Command.AddParameter("Email", Email,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("Signature", Signature,DbType.String,ParameterDirection.Input);
										return sp;
				}
				
				
	public StoredProcedure UsersUpdateActiveCode(string Email, string ActiveCode){
							var sp=new StoredProcedure("MF_UsersUpdateActiveCode",this.Provider);
									sp.Command.AddParameter("Email", Email,DbType.AnsiString,ParameterDirection.Input);
													sp.Command.AddParameter("ActiveCode", ActiveCode,DbType.AnsiString,ParameterDirection.Input);
										return sp;
				}
				
								
			}
		}
